<html>
    <head>
        <?php include './sethead.php'; ?>
        <title>View Equipment</title>
        <script type="text/javascript" charset="utf-8">
                $(document).ready(function() {
                        $('#menu_view').addClass("active");
                        $('#example').dataTable();
                } );
        </script>
    </head>
    <body>
        <div class="main">
            <?php
                include './menu.php';
            ?>
            <div class="headpage">
                View Equipment
            </div>
            <div class="bodypage bgBody">
                <table class="dataTable" id="example" width="100%" border="0">
                    <thead>
                        <tr>
                            <th>
                                Chassis
                            </th>
                            <th>
                                ITD Asset No
                            </th>
                            <th>
                                Description
                            </th>
                            <th>
                                Brand
                            </th>
                            <th>
                                HP
                            </th>
                            <th>
                                Location
                            </th>
                            <th>
                                SuoolierCode
                            </th>
                            <th>
                                Job
                            </th>
                        </tr>
                    </thead>
                    <tbody>
                    <?php
                        $strSQL = "SELECT `Chassis`, `ITDAssetNo`, `Description`, `Brand`, `HP`, `Location`, `SupplierCode`, `Job` FROM `equipment` WHERE 1  ";
                        $objQuery = mysqli_query($MechanicDB, $strSQL);
                        while($row = $objQuery->fetch_array()){
                    ?>
                        <tr>
                            <td>
                                <?=$row["Chassis"]?>
                            </td>
                            <td>
                                <?=$row["ITDAssetNo"]?>
                            </td>
                            <td>
                                <?=$row["Description"]?>
                            </td>
                            <td>
                                <?=$row["Brand"]?>
                            </td>
                            <td>
                                <?=$row["HP"]?>
                            </td>
                            <td>
                                <?=$row["Location"]?>
                            </td>
                            <td>
                                <?=$row["SupplierCode"]?>
                            </td>
                            <td>
                                <?=$row["Job"]?>
                            </td>
                        </tr>
                    <?php
                        }
                    ?>
                    </tbody>
                </table>
            </div>
        </div>
    </body>
</html>